
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
	<head>
		<title>Hibernate Mappings - Table Info</title>
		<link rel="stylesheet" type="text/css" href="../../assets/doc-style.css" title="Style"/>
	</head>
	<body>

	<div id="header">

		<div id="logo">
			<a href="http://www.hibernate.org/" target="_blank">
				<img src="../../assets/hibernate_logo.gif" alt="Hibernate"/>
			</a>
		</div>

		<ul><li><a href="../index.html" target="_top">Tables</a></li><li><a href="../../entities/index.html" target="_top">Entities</a></li></ul>

		<hr/>

	</div>

		<h4>Schema magento.default</h4>
		<h2>Table paypal_settlement_report_row</h2>

			<p></p>

		<table id="column_summary">
			<thead>
				<tr>
					<th class="MainTableHeading" colspan="7">
						Column Summary
					</th>
				</tr>
				<tr>
					<th style="width: 14%">
						Name
					</th>
					<th style="width: 14%">
						SqlType
					</th>
					<th style="width: 14%">
						Length
					</th>
					<th style="width: 14%">
						Precision
					</th>
					<th style="width: 14%">
						Scale
					</th>
					<th style="width: 14%">
						Nullable
					</th>
					<th style="width: 14%">
						Unique
					</th>
				</tr>
			</thead>
			<tbody>
					<tr>
						<td>
							<a href="#column_detail_row_id">
								row_id
							</a>
						</td>
						<td>
							integer
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							true
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_report_id">
								report_id
							</a>
						</td>
						<td>
							N/D
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_transaction_id">
								transaction_id
							</a>
						</td>
						<td>
							varchar(19)
						</td>
						<td>
							19
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_invoice_id">
								invoice_id
							</a>
						</td>
						<td>
							varchar(127)
						</td>
						<td>
							127
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_paypal_reference_id">
								paypal_reference_id
							</a>
						</td>
						<td>
							varchar(19)
						</td>
						<td>
							19
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_paypal_reference_id_type">
								paypal_reference_id_type
							</a>
						</td>
						<td>
							varchar(3)
						</td>
						<td>
							3
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_transaction_event_code">
								transaction_event_code
							</a>
						</td>
						<td>
							varchar(5)
						</td>
						<td>
							5
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_transaction_initiation_date">
								transaction_initiation_date
							</a>
						</td>
						<td>
							datetime
						</td>
						<td>
							19
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_transaction_completion_date">
								transaction_completion_date
							</a>
						</td>
						<td>
							datetime
						</td>
						<td>
							19
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_transaction_debit_or_credit">
								transaction_debit_or_credit
							</a>
						</td>
						<td>
							varchar(2)
						</td>
						<td>
							2
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_gross_transaction_amount">
								gross_transaction_amount
							</a>
						</td>
						<td>
							decimal(20,6)
						</td>
						<td>
							255
						</td>
						<td>
							20
						</td>
						<td>
							6
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_gross_transaction_currency">
								gross_transaction_currency
							</a>
						</td>
						<td>
							varchar(3)
						</td>
						<td>
							3
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_fee_debit_or_credit">
								fee_debit_or_credit
							</a>
						</td>
						<td>
							varchar(2)
						</td>
						<td>
							2
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_fee_amount">
								fee_amount
							</a>
						</td>
						<td>
							decimal(20,6)
						</td>
						<td>
							255
						</td>
						<td>
							20
						</td>
						<td>
							6
						</td>
						<td>
							false
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_fee_currency">
								fee_currency
							</a>
						</td>
						<td>
							varchar(3)
						</td>
						<td>
							3
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_custom_field">
								custom_field
							</a>
						</td>
						<td>
							varchar(255)
						</td>
						<td>
							255
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
					<tr>
						<td>
							<a href="#column_detail_consumer_id">
								consumer_id
							</a>
						</td>
						<td>
							varchar(127)
						</td>
						<td>
							127
						</td>
						<td>
							19
						</td>
						<td>
							2
						</td>
						<td>
							true
						</td>
						<td>
							false
						</td>
					</tr>
			</tbody>
		</table>

		<table id="primary_key">
			<thead>
				<tr>
					<th class="MainTableHeading" colspan="2">
						Primary Key
					</th>
				</tr>
				<tr>
					<th style="width: 50%">
						Name
					</th>
					<th style="width: 50%">
						Columns
					</th>
				</tr>
			</thead>
			<tbody>
					<tr>
						<td>
								PRIMARY
						</td>
						<td>
								<a href="#column_detail_row_id">
									row_id
								</a>
						</td>
					</tr>
			</tbody>
		</table>

			<table id="foreign_keys">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="3">
							Foreign Keys
						</th>
					</tr>
					<tr>
						<th style="width: 33%">
							Name
						</th>
						<th style="width: 33%">
							Referenced Table
						</th>
						<th style="width: 33%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								FK_E183E488F593E0DE10C6EBFFEBAC9B55
							</td>
							<td>
								<a href="paypal_settlement_report.html" target="generalFrame">
									paypal_settlement_report
								</a>
							</td>
							<td>
									<a href="#column_detail_report_id">
										report_id
									</a>
							</td>
						</tr>
						<tr>
							<td>
								FKDDF7C4D9619A30F6
							</td>
							<td>
								<a href="paypal_settlement_report.html" target="generalFrame">
									paypal_settlement_report
								</a>
							</td>
							<td>
									<a href="#column_detail_report_id">
										report_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
			
			<table id="unique_keys">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="2">
							Unique Keys
						</th>
					</tr>
					<tr>
						<th style="width: 50%">
							Name
						</th>
						<th style="width: 50%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								PRIMARY
							</td>
							<td>
									<a href="#column_detail_row_id">
										row_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
		
			<table id="indexes">
				<thead>
					<tr>
						<th class="MainTableHeading" colspan="2">
							Indexes
						</th>
					</tr>
					<tr>
						<th style="width: 50%">
							Name
						</th>
						<th style="width: 50%">
							Columns
						</th>
					</tr>
				</thead>
				<tbody>
						<tr>
							<td>
								IDX_PAYPAL_SETTLEMENT_REPORT_ROW_REPORT_ID
							</td>
							<td>
									<a href="#column_detail_report_id">
										report_id
									</a>
							</td>
						</tr>
				</tbody>
			</table>
		
			<p id="column_detail" class="MainTableHeading">
				Column Detail
			</p>
				
				<h3 id="column_detail_row_id">row_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> integer
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> true
					</li>
					<li>
						<strong>Comment:</strong> Row Id
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_report_id">report_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> N/D
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Report Id
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_transaction_id">transaction_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(19)
					</li>
					<li>
						<strong>Length:</strong> 19
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Transaction Id
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_invoice_id">invoice_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(127)
					</li>
					<li>
						<strong>Length:</strong> 127
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Invoice Id
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_paypal_reference_id">paypal_reference_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(19)
					</li>
					<li>
						<strong>Length:</strong> 19
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Paypal Reference Id
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_paypal_reference_id_type">paypal_reference_id_type</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(3)
					</li>
					<li>
						<strong>Length:</strong> 3
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Paypal Reference Id Type
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_transaction_event_code">transaction_event_code</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(5)
					</li>
					<li>
						<strong>Length:</strong> 5
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Transaction Event Code
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_transaction_initiation_date">transaction_initiation_date</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> datetime
					</li>
					<li>
						<strong>Length:</strong> 19
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Transaction Initiation Date
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_transaction_completion_date">transaction_completion_date</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> datetime
					</li>
					<li>
						<strong>Length:</strong> 19
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Transaction Completion Date
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_transaction_debit_or_credit">transaction_debit_or_credit</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(2)
					</li>
					<li>
						<strong>Length:</strong> 2
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Transaction Debit Or Credit
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_gross_transaction_amount">gross_transaction_amount</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(20,6)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 20
					</li>
					<li>
						<strong>Scale:</strong> 6
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Gross Transaction Amount
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_gross_transaction_currency">gross_transaction_currency</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(3)
					</li>
					<li>
						<strong>Length:</strong> 3
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Gross Transaction Currency
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_fee_debit_or_credit">fee_debit_or_credit</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(2)
					</li>
					<li>
						<strong>Length:</strong> 2
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Fee Debit Or Credit
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_fee_amount">fee_amount</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> decimal(20,6)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 20
					</li>
					<li>
						<strong>Scale:</strong> 6
					</li>
					<li>
						<strong>Nullable:</strong> false
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Fee Amount
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_fee_currency">fee_currency</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(3)
					</li>
					<li>
						<strong>Length:</strong> 3
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Fee Currency
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_custom_field">custom_field</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(255)
					</li>
					<li>
						<strong>Length:</strong> 255
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Custom Field
					</li>
				</ul>


				<hr/>
				<h3 id="column_detail_consumer_id">consumer_id</h3>
				
				<ul>
					<li>
						<strong>Type:</strong> varchar(127)
					</li>
					<li>
						<strong>Length:</strong> 127
					</li>
					<li>
						<strong>Precision:</strong> 19
					</li>
					<li>
						<strong>Scale:</strong> 2
					</li>
					<li>
						<strong>Nullable:</strong> true
					</li>
					<li>
						<strong>Unique:</strong> false
					</li>
					<li>
						<strong>Comment:</strong> Consumer Id
					</li>
				</ul>


				<hr/>
				

	</body>
</html>
